Re: How to create an aggregate? - Mailing list pgsql-sql

From Ray Aspeitia
Subject Re: How to create an aggregate?
Date
Msg-id p06002000bd33ea2982b9@[192.168.5.55]
Whole thread Raw
In response to Re: How to create an aggregate?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
So the AGGREGATE function also references parameters like a regular 
SQL function. Good to know.

Figured I'd ask anyway. Thanks for the info Tom, Greg.

Ray A.


>
>  > I also would like to pass the delimiter to the aggregate as a parameter
>>  and I am not sure if it can handle that.
>
>It can't.  You'll need a single-argument finalfunc that hardwires the
>delimiter, ie,
>        array_to_string($1, '|')
>
>            regards, tom lane


-- 
Ray Aspeitia
Sells Printing Company LLC
aspeitia@sells.com
(262) 317-8314


pgsql-sql by date:

Previous
From: Smita Marda
Date:
Subject: org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143)
Next
From: Kaloyan Iliev Iliev
Date:
Subject: Problems with UNION ALL and ORDER BY